INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('UPLOAD_FILE_STATUS', '0', '待檢核 ', 1);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('UPLOAD_FILE_STATUS', '1', '檢查中', 2);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('UPLOAD_FILE_STATUS', '2', '檢核未通過 ', 3);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('UPLOAD_FILE_STATUS', '3', '待放行', 4);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('UPLOAD_FILE_STATUS', '4', '已放行', 5);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('UPLOAD_FILE_STATUS', '5', '已刪除', 6);

INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('PAYMENT_STATUS', '1', '待放行', 1);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('PAYMENT_STATUS', '2', '待繳款', 2);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('PAYMENT_STATUS', '3', '註銷中', 3);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('PAYMENT_STATUS', '4', '已註銷', 4);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('PAYMENT_STATUS', '5', '已繳款', 5);

INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('CHANEL', '0', '臨櫃繳款', 1);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('CHANEL', '1', '網路銀行', 2);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('CHANEL', '2', 'ATM或網路ATM', 3);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('CHANEL', '3', '中心轉帳BIO', 4);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('CHANEL', '4', '自行XML', 5);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('CHANEL', '8', '跨行匯款', 6);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('CHANEL', 'Z', '自行繳款', 7);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('CHANEL', 'D', '7-11', 8);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('CHANEL', 'E', '全家', 9);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('CHANEL', 'F', '萊爾富', 10);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('CHANEL', 'G', 'OK', 11);
INSERT INTO CODE_TABLE ( CODE_KIND,  CODE_VALUE,  CODE_NAME,  SORT_INDEX) VALUES ('CHANEL', 'H', '郵局', 12);

-- 手續費代碼檔
insert into COMMISSION_CODE_TABLE (COMMISSION_CODE, COMMISSION_CODE_NAME, AMOUNT_SCOPE_S, AMOUNT_SCOPE_E, COMMISSION_TYPE, COMMISSION_AMOUNT, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE, BANK_AMOUNT) values ('AFF', '超商高中、高職學雜費外加', 1, 20000, 'O', 10, '000000000001_admin', '2011-01-07 15:27:02', '000000000001_admin', '2011-01-07 15:27:02', 5);
insert into COMMISSION_CODE_TABLE (COMMISSION_CODE, COMMISSION_CODE_NAME, AMOUNT_SCOPE_S, AMOUNT_SCOPE_E, COMMISSION_TYPE, COMMISSION_AMOUNT, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE, BANK_AMOUNT) values ('AFG', '超商高中、高職學雜費外加', 20001, 40000, 'O', 15, '000000000001_admin', '2011-01-07 15:27:02', '000000000001_admin', '2011-01-07 15:27:02', 5);
insert into COMMISSION_CODE_TABLE (COMMISSION_CODE, COMMISSION_CODE_NAME, AMOUNT_SCOPE_S, AMOUNT_SCOPE_E, COMMISSION_TYPE, COMMISSION_AMOUNT, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE, BANK_AMOUNT) values ('AFH', '超商高中、高職學雜費外加', 40001, 60000, 'O', 20, '000000000001_admin', '2011-01-07 15:27:02', '000000000001_admin', '2011-01-07 15:27:02', 5);
insert into COMMISSION_CODE_TABLE (COMMISSION_CODE, COMMISSION_CODE_NAME, AMOUNT_SCOPE_S, AMOUNT_SCOPE_E, COMMISSION_TYPE, COMMISSION_AMOUNT, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE, BANK_AMOUNT) values ('AFI', '超商高中、高職學雜費外加', 60001, 80000, 'O', 30, '000000000001_admin', '2011-01-07 15:27:02', '000000000001_admin', '2011-01-07 15:27:02', 5);
insert into COMMISSION_CODE_TABLE (COMMISSION_CODE, COMMISSION_CODE_NAME, AMOUNT_SCOPE_S, AMOUNT_SCOPE_E, COMMISSION_TYPE, COMMISSION_AMOUNT, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE, BANK_AMOUNT) values ('AFD', '超商國中、小學學雜費內含', 20001, 40000, 'I', 15, '000000000001_admin', '2011-01-07 15:27:02', '000000000001_admin', '2011-01-07 15:27:02', 5);
insert into COMMISSION_CODE_TABLE (COMMISSION_CODE, COMMISSION_CODE_NAME, AMOUNT_SCOPE_S, AMOUNT_SCOPE_E, COMMISSION_TYPE, COMMISSION_AMOUNT, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE, BANK_AMOUNT) values ('000', '遠銀代收通路', 1, 9999999, 'O', 0, '000000000001_admin', '2011-01-07 15:27:02', '000000000001_admin', '2011-01-07 15:27:02', 5);
insert into COMMISSION_CODE_TABLE (COMMISSION_CODE, COMMISSION_CODE_NAME, AMOUNT_SCOPE_S, AMOUNT_SCOPE_E, COMMISSION_TYPE, COMMISSION_AMOUNT, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE, BANK_AMOUNT) values ('ZZZ', '郵局代收', 1, 9999999, 'O', 15, '000000000001_admin', '2011-01-07 15:27:02', '000000000001_admin', '2011-01-07 15:27:02', 5);
insert into COMMISSION_CODE_TABLE (COMMISSION_CODE, COMMISSION_CODE_NAME, AMOUNT_SCOPE_S, AMOUNT_SCOPE_E, COMMISSION_TYPE, COMMISSION_AMOUNT, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE, BANK_AMOUNT) values ('AFC', '超商國中、小學學雜費內含', 1, 20000, 'I', 6, '000000000001_admin', '2011-01-07 15:27:02', '000000000001_admin', '2011-01-07 15:27:02', 5);
insert into COMMISSION_CODE_TABLE (COMMISSION_CODE, COMMISSION_CODE_NAME, AMOUNT_SCOPE_S, AMOUNT_SCOPE_E, COMMISSION_TYPE, COMMISSION_AMOUNT, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE, BANK_AMOUNT) values ('AFE', '超商國中、小學學雜費外加', 1, 20000, 'O', 6, '000000000001_admin', '2011-01-07 15:27:02', '000000000001_admin', '2011-01-07 15:27:02', 5);
insert into COMMISSION_CODE_TABLE (COMMISSION_CODE, COMMISSION_CODE_NAME, AMOUNT_SCOPE_S, AMOUNT_SCOPE_E, COMMISSION_TYPE, COMMISSION_AMOUNT, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE, BANK_AMOUNT) values ('6NX', '超商一般代收內含', 1, 20000, 'I', 10, '000000000001_admin', '2011-01-07 15:27:02', '000000000001_admin', '2011-01-07 15:27:02', 5);
insert into COMMISSION_CODE_TABLE (COMMISSION_CODE, COMMISSION_CODE_NAME, AMOUNT_SCOPE_S, AMOUNT_SCOPE_E, COMMISSION_TYPE, COMMISSION_AMOUNT, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE, BANK_AMOUNT) values ('6NY', '超商一般代收內含', 20001, 40000, 'I', 15, '000000000001_admin', '2011-01-07 15:27:02', '000000000001_admin', '2011-01-07 15:27:02', 5);
insert into COMMISSION_CODE_TABLE (COMMISSION_CODE, COMMISSION_CODE_NAME, AMOUNT_SCOPE_S, AMOUNT_SCOPE_E, COMMISSION_TYPE, COMMISSION_AMOUNT, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE, BANK_AMOUNT) values ('6NZ', '超商一般代收外加', 1, 20000, 'O', 10, '000000000001_admin', '2011-01-07 15:27:02', '000000000001_admin', '2011-01-07 15:27:02', 5);
insert into COMMISSION_CODE_TABLE (COMMISSION_CODE, COMMISSION_CODE_NAME, AMOUNT_SCOPE_S, AMOUNT_SCOPE_E, COMMISSION_TYPE, COMMISSION_AMOUNT, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE, BANK_AMOUNT) values ('6OA', '超商一般代收外加', 20001, 40000, 'O', 15, '000000000001_admin', '2011-01-07 15:27:02', '000000000001_admin', '2011-01-07 15:27:02', 5);


-- 群組主檔
SET IDENTITY_INSERT APP_GROUP ON
GO
INSERT INTO APP_GROUP (GROUP_PK, GROUP_NO, GROUP_NAME, GROUP_TYPE, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (1, '000000000001', '遠東商業銀行',  1, 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_GROUP (GROUP_PK, GROUP_NO, GROUP_NAME, GROUP_TYPE, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (2, '360798880001', '私立豫章高級工商職業學校',  2, 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_GROUP (GROUP_PK, GROUP_NO, GROUP_NAME, GROUP_TYPE, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (3, '705439780001', '經貿聯網股份有限公司',  2, 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
GO
SET IDENTITY_INSERT APP_GROUP OFF
GO

-- 使用者主檔
SET IDENTITY_INSERT APP_USER ON
GO
INSERT INTO APP_USER (USER_PK, GROUP_PK, USER_ID, USER_PWD, USER_NAME, USER_EMAIL,  IS_ENABLED, IS_LOCKED, PWD_EXPIRED_DATE, PWD_HISTORY, PWD_ERROR_TIME, USER_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (1, 1, 'admin', '1c63129ae9db9c60c3e8aa94d3e00495', '遠東商銀管理者', 'latte1855@gmail.com', 1, 0,  GETDATE() + 90, NULL, 0, NULL, 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_USER (USER_PK, GROUP_PK, USER_ID, USER_PWD, USER_NAME, USER_EMAIL,  IS_ENABLED, IS_LOCKED, PWD_EXPIRED_DATE, PWD_HISTORY, PWD_ERROR_TIME, USER_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (2, 2, 'admin', '1c63129ae9db9c60c3e8aa94d3e00495', '豫章工商管理者', 'latte1855@gmail.com', 1, 0,  GETDATE() + 90, NULL, 0, NULL, 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_USER (USER_PK, GROUP_PK, USER_ID, USER_PWD, USER_NAME, USER_EMAIL,  IS_ENABLED, IS_LOCKED, PWD_EXPIRED_DATE, PWD_HISTORY, PWD_ERROR_TIME, USER_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (3, 3, 'admin', '1c63129ae9db9c60c3e8aa94d3e00495', '經貿聯網管理者', 'latte1855@gmail.com', 1, 0,  GETDATE() + 90, NULL, 0, NULL, 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_USER (USER_PK, GROUP_PK, USER_ID, USER_PWD, USER_NAME, USER_EMAIL,  IS_ENABLED, IS_LOCKED, PWD_EXPIRED_DATE, PWD_HISTORY, PWD_ERROR_TIME, USER_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (4, 2, 'ycvs01', '1c63129ae9db9c60c3e8aa94d3e00495', '豫章經辦', 'latte1855@gmail.com', 1, 0,  GETDATE() + 90, NULL, 0, NULL, 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_USER (USER_PK, GROUP_PK, USER_ID, USER_PWD, USER_NAME, USER_EMAIL,  IS_ENABLED, IS_LOCKED, PWD_EXPIRED_DATE, PWD_HISTORY, PWD_ERROR_TIME, USER_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (5, 2, 'ycvs02', '1c63129ae9db9c60c3e8aa94d3e00495', '豫章主管', 'latte1855@gmail.com', 1, 0,  GETDATE() + 90, NULL, 0, NULL, 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_USER (USER_PK, GROUP_PK, USER_ID, USER_PWD, USER_NAME, USER_EMAIL,  IS_ENABLED, IS_LOCKED, PWD_EXPIRED_DATE, PWD_HISTORY, PWD_ERROR_TIME, USER_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (6, 3, 'cybersoft01', '1c63129ae9db9c60c3e8aa94d3e00495', '經貿經辦', 'latte1855@gmail.com', 1, 0,  GETDATE() + 90, NULL, 0, NULL, 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_USER (USER_PK, GROUP_PK, USER_ID, USER_PWD, USER_NAME, USER_EMAIL,  IS_ENABLED, IS_LOCKED, PWD_EXPIRED_DATE, PWD_HISTORY, PWD_ERROR_TIME, USER_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (7, 3, 'cybersoft02', '1c63129ae9db9c60c3e8aa94d3e00495', '經貿主管', 'latte1855@gmail.com', 1, 0,  GETDATE() + 90, NULL, 0, NULL, 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
GO
SET IDENTITY_INSERT APP_USER OFF
GO

-- 角色主檔
SET IDENTITY_INSERT APP_ROLE ON
GO
INSERT INTO APP_ROLE (ROLE_PK, GROUP_PK, ROLE_NO, ROLE_NAME, ROLE_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (1, 1, 'ADMINISTRATOR',  '銀行端系統管理角色', NULL, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_ROLE (ROLE_PK, GROUP_PK, ROLE_NO, ROLE_NAME, ROLE_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (2, 2, 'ADMINISTRATOR',  '系統管理角色', NULL, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_ROLE (ROLE_PK, GROUP_PK, ROLE_NO, ROLE_NAME, ROLE_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (3, 3, 'ADMINISTRATOR',  '系統管理角色', NULL, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_ROLE (ROLE_PK, GROUP_PK, ROLE_NO, ROLE_NAME, ROLE_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (4, 2, 'WORKER',  '經辦', NULL, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_ROLE (ROLE_PK, GROUP_PK, ROLE_NO, ROLE_NAME, ROLE_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (5, 2, 'OFFICER',  '主管', NULL, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_ROLE (ROLE_PK, GROUP_PK, ROLE_NO, ROLE_NAME, ROLE_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (6, 3, 'WORKER',  '經辦', NULL, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO APP_ROLE (ROLE_PK, GROUP_PK, ROLE_NO, ROLE_NAME, ROLE_MEMO, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (7, 3, 'OFFICER',  '主管', NULL, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
GO
SET IDENTITY_INSERT APP_ROLE OFF
GO

-- 使用者對角色主檔
INSERT INTO USER_ROLE (USER_PK, ROLE_PK) VALUES (1, 1);
INSERT INTO USER_ROLE (USER_PK, ROLE_PK) VALUES (2, 2);
INSERT INTO USER_ROLE (USER_PK, ROLE_PK) VALUES (3, 3);
INSERT INTO USER_ROLE (USER_PK, ROLE_PK) VALUES (4, 4);
INSERT INTO USER_ROLE (USER_PK, ROLE_PK) VALUES (5, 5);
INSERT INTO USER_ROLE (USER_PK, ROLE_PK) VALUES (6, 6);
INSERT INTO USER_ROLE (USER_PK, ROLE_PK) VALUES (7, 7);
GO

-- 程式主檔
SET IDENTITY_INSERT MENU_ITEM ON
GO
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (1, 'SOEZ1000', null, null, 1, 1, 1, 100, null, '帳單管理', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (2, 'SOEZ2000', null, null, 1, 1, 1, 200, null, '放行作業', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (3, 'SOEZ3000', null, null, 1, 1, 1, 300, null, '列印作業', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (4, 'SOEZ5000', null, null, 0, 1, 1, 400, null, '管理報表', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (5, 'SOEZ9000', null, null, 1, 1, 1, 500, null, '系統管理', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (6, 'SOEZO000', null, null, 0, NULL, NULL, 600, null, '其他功能', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());


INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (7, 'SOEZ1011', 1, '/Soez1011.action', 0, NULL, 1, 311, 'Soez1011ActionBean', '繳款人資料整批上傳', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (8, 'SOEZ1012', 1, '/Soez1012.action', 1, 1, 1, 312, 'Soez1012ActionBean', '帳單明細資料上傳', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (9, 'SOEZ1013', 1, '/Soez1013.action', 0, 1, 1, 313, 'Soez1013ActionBean', '查詢繳費狀況', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (10, 'SOEZ1014', 1, '/Soez1014.action', 0, 1, 1, 314, 'Soez1014ActionBean', '查詢繳費明細', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (11, 'SOEZ1015', 1, '/Soez1015.action', 0, NULL, 1, 315, 'Soez1015ActionBean', '繳款人資料維護', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (12, 'SOEZ1016', 1, '/Soez1016.action', 1, 1, 1, 316, 'Soez1016ActionBean', '帳單註銷作業', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (13, 'SOEZ1017', 1, '/Soez1017.action', 1, 1, 1, 317, 'Soez1017ActionBean', '帳單核銷作業', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (14, 'SOEZ1018', 1, '/Soez1018.action', 1, 1, 1, 318, 'Soez1018ActionBean', '帳單明細資料下載', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (15, 'SOEZ1019', 1, '/Soez1019.action', 0, NULL, 1, 319, 'Soez1019ActionBean', '自動產生繳款單', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());

INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (16, 'SOEZ2001', 2, '/Soez2001.action', 0, NULL, 1, 201, 'Soez2001ActionBean', '繳款人資料單筆放行', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (17, 'SOEZ2002', 2, '/Soez2002.action', 0, NULL, 1, 202, 'Soez2002ActionBean', '繳款人資料上傳放行', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (18, 'SOEZ2003', 2, '/Soez2003.action', 1, 1, 1, 203, 'Soez2003ActionBean', '帳單上傳放行', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (19, 'SOEZ2004', 2, '/Soez2004.action', 1, 1, 1, 204, 'Soez2004ActionBean', '帳單註銷放行', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (20, 'SOEZ2005', 2, '/Soez2005.action', 1, 1, 1, 205, 'Soez2005ActionBean', '帳單核銷放行', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());


INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (21, 'SOEZ3001', 3, '/Soez3001.action', 1, 1, 1, 301, 'Soez3001ActionBean', '區間帳單列印', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (22, 'SOEZ3002', 3, '/Soez3002.action', 1, 1, 1, 302, 'Soez3002ActionBean', '整批帳單下載', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());

INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (23, 'SOEZ5001', 4, '/Soez5001.action', 0, 1, 1, 401, 'Soez5001ActionBean', '異常繳費明細表', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (24, 'SOEZ5002', 4, '/Soez5002.action', 0, 1, 1, 402, 'Soez5002ActionBean', '繳費狀況明細表', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (25, 'SOEZ5003', 4, '/Soez5003.action', 0, 1, 1, 403, 'Soez5003ActionBean', '繳費通路統計表', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (26, 'SOEZ5004', 4, '/Soez5004.action', 0, 1, 1, 404, 'Soez5004ActionBean', '帳單業者清算報表', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (27, 'SOEZ5005', 4, '/Soez5005.action', 0, 1, 1, 405, 'Soez5005ActionBean', '代收收益統計表', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());



INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (28, 'SOEZ9001', 5, '/Soez9001.action', 1, 1, 1, 501, 'Soez9001ActionBean', '帳號維護作業', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (29, 'SOEZ9002', 5, '/Soez9002.action', 1, 1, 1, 502, 'Soez9002ActionBean', '角色維護作業', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (30, 'SOEZ9003', 5, '/Soez9003.action', 1, NULL, NULL, 503, 'Soez9003ActionBean', '權限功能設定', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (31, 'SOEZ9004', 1, '/Soez9004.action', 1, 1, 1, 504, 'Soez9004ActionBean', '上傳記錄查詢', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (32, 'SOEZ9005', 5, '/Soez9005.action', 1, NULL, NULL, 505, 'Soez9005ActionBean', '手續費設定', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (33, 'SOEZ9006', 5, '/Soez9006.action', 0, NULL, NULL, 506, 'Soez9006ActionBean', '交易日誌查詢', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (34, 'SOEZ9007', 5, '/Soez9007.action', 0, NULL, NULL, 507, 'Soez9007ActionBean', '帳單業者設定', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (35, 'SOEZ9008', 5, '/Soez9008.action', 0, NULL, NULL, 508, 'Soez9008ActionBean', '帳單項目設定', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (36, 'SOEZ9009', 5, '/Soez9009.action', 0, NULL, NULL, 509, 'Soez9009ActionBean', '上傳檔案定義', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (37, 'SOEZ9010', 5, '/Soez9010.action', 1, 1, 1, 510, 'Soez9010ActionBean', '基本資料修改', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (38, 'SOEZ9011', 5, '/Soez9011.action', 1, 1, 1, 511, 'Soez9011ActionBean', '登入密碼修改', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO MENU_ITEM (MENU_ITEM_PK, MENU_ID, PARENT_MENU_ITEM_PK, ACTION_PAGE, IS_ENABLED, IS_SCHOOL, IS_COMMITTEE, ORDER_NO, ACTION_BAEN, ACTION_NAME, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (39, 'SOEZ9012', 5, '/Soez9012.action', 1, 1, 1, 512, 'Soez9012ActionBean', '強迫登出功能', 'CYBERSOFT',  GETDATE(), 'CYBERSOFT', GETDATE());

GO
SET IDENTITY_INSERT MENU_ITEM OFF
GO

-- 角色對程式主檔
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 1);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 2);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 3);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 4);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 5);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 6);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 7);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 8);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 9);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 10);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 11);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 12);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 13);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 14);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 15);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 16);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 17);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 18);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 19);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 20);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 21);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 22);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 23);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 24);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 25);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 26);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 27);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 28);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 29);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 30);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 31);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 32);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 33);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 34);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 35);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 36);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 37);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 38);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (1, 39);

GO

-- 豫章ADMINISTRATOR
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (2, 5);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (2, 28);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (2, 29);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (2, 38);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (2, 39);

GO

-- 豫章經辦
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (4, 5);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (4, 31);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (4, 38);

INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (4, 1);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (4, 8);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (4, 12);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (4, 13);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (4, 14);

INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (4, 3);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (4, 21);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (4, 22);


-- 豫章主管
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (5, 5);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (5, 38);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (5, 31);

INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (5, 1);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (5, 14);

INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (5, 2);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (5, 18);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (5, 19);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (5, 20);

INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (5, 3);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (5, 21);
INSERT INTO ROLE_MENU (ROLE_PK, MENU_ITEM_PK) VALUES (5, 22);

GO

-- 豫章學雜費  帳單匯入格式(主檔)
SET IDENTITY_INSERT FORMAT_DEFINITION ON
GO
INSERT INTO FORMAT_DEFINITION (FORMAT_DEF_PK, GROUP_PK, FORMAT_NAME, IS_DELETED, CUSTOM_VALIDATE_CLASS, JRXML_PATH, CUSTOM_PDF_CLASS, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (1, 2, '豫章工商學雜費規格', 0, 'com.feib.soeasy.job.importor.YcvsValidator', 'E:/workspace/feib.soeasy/soeasy/src/main/webapp/reports/ycvsReport.jrxml', null, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO FORMAT_DEFINITION (FORMAT_DEF_PK, GROUP_PK, FORMAT_NAME, IS_DELETED, CUSTOM_VALIDATE_CLASS, JRXML_PATH, CUSTOM_PDF_CLASS, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (2, 2, '豫章工商實習商店規格', 0, 'com.feib.soeasy.job.importor.YcvsValidator', 'E:/workspace/feib.soeasy/soeasy/src/main/webapp/reports/ycvsWorkReport.jrxml', null, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
GO
SET IDENTITY_INSERT FORMAT_DEFINITION OFF
GO

insert into FORMAT_DEF_COMMISSION (COMMISSION_CODE_PK, FORMAT_DEF_PK) values (1, 1);
insert into FORMAT_DEF_COMMISSION (COMMISSION_CODE_PK, FORMAT_DEF_PK) values (2, 1);
insert into FORMAT_DEF_COMMISSION (COMMISSION_CODE_PK, FORMAT_DEF_PK) values (3, 1);
insert into FORMAT_DEF_COMMISSION (COMMISSION_CODE_PK, FORMAT_DEF_PK) values (4, 1);
insert into FORMAT_DEF_COMMISSION (COMMISSION_CODE_PK, FORMAT_DEF_PK) values (1, 2);
insert into FORMAT_DEF_COMMISSION (COMMISSION_CODE_PK, FORMAT_DEF_PK) values (2, 2);
insert into FORMAT_DEF_COMMISSION (COMMISSION_CODE_PK, FORMAT_DEF_PK) values (3, 2);
insert into FORMAT_DEF_COMMISSION (COMMISSION_CODE_PK, FORMAT_DEF_PK) values (4, 2);


-- 豫章學雜費  帳單匯入格式(明細)
SET IDENTITY_INSERT COLUMN_DEFINITION ON
GO
/**Header**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES ( 1, 1, 1, 'attribute1', '主辦銀行', '1', 1, 40, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES ( 2, 1, 1, 'attribute2', '入帳帳號', '1', 41, 54, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES ( 3, 1, 1, 'paymentName', '繳費類別', '1', 55, 74, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**繳費期限**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES ( 4, 1, 1, 'payDue', '繳費期限', '3', 75, 82, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES ( 5, 1, 1, 'virtualAccount', '繳費帳號', '1', 83, 96, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES ( 6, 1, 1, 'payerName', '姓名', '1', 97, 108, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES ( 7, 1, 1, 'studentId', '學號', '1', 109, 114, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES ( 8, 1, 1, 'department', '科別', '1', 115, 126, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES ( 9, 1, 1, 'seatNo', '座號', '1', 127, 129, 0, 0, 0, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (10, 1, 1, 'attribute3', '減免項目', '1', 130, 149, 0, 0, 0, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());

/**Items**/
/**學費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (11, 1, 0, 'itemName', '繳費項目', '1', 150, 169, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (12, 1, 0, 'amount', '金額', '2', 170, 176, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**雜費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (13, 1, 0, 'itemName', '繳費項目', '1', 177, 196, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (14, 1, 0, 'amount', '金額', '2', 197, 203, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**實習費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (15, 1, 0, 'itemName', '繳費項目', '1', 204, 223, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (16, 1, 0, 'amount', '金額', '2', 224, 230, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**不可貸學雜費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (17, 1, 0, 'itemName', '繳費項目', '1', 231, 250, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (18, 1, 0, 'amount', '金額', '2', 251, 257, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**原住民助學**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (19, 1, 0, 'itemName', '繳費項目', '1', 258, 277, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (20, 1, 0, 'amount', '金額', '2', 278, 284, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**原住民伙食**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (21, 1, 0, 'itemName', '繳費項目', '1', 285, 304, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (22, 1, 0, 'amount', '金額', '2', 305, 311, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**學雜費補助**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (23, 1, 0, 'itemName', '繳費項目', '1', 312, 331, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (24, 1, 0, 'amount', '金額', '2', 332, 338, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**減免補助學**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (25, 1, 0, 'itemName', '繳費項目', '1', 339, 358, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (26, 1, 0, 'amount', '金額', '2', 359, 365, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**平安保險費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (27, 1, 0, 'itemName', '繳費項目', '1', 366, 385, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (28, 1, 0, 'amount', '金額', '2', 386, 392, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**可貸書籍費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (29, 1, 0, 'itemName', '繳費項目', '1', 393, 412, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (30, 1, 0, 'amount', '金額', '2', 413, 419, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());

/**Header**/
/**應繳金額**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (31, 1, 1, 'attribute4', '應繳金額', '2', 440, 446, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**手續費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (32, 1, 1, 'attribute5', '手續費', '2', 467, 473, 0, 0, 0, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**實繳金額**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (33, 1, 1, 'attribute6', '實繳金額', '2', 494, 500, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**可助學**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (34, 1, 1, 'attribute7', '可助學', '2', 521, 527, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());

/**Items**/
/**電腦維護費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (35, 1, 0, 'itemName', '繳費項目', '1', 528, 547, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (36, 1, 0, 'amount', '金額', '2', 548, 554, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**網路使用費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (37, 1, 0, 'itemName', '繳費項目', '1', 555, 574, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (38, 1, 0, 'amount', '金額', '2', 575, 581, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**班費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (39, 1, 0, 'itemName', '繳費項目', '1', 582, 601, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (40, 1, 0, 'amount', '金額', '2', 602, 608, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**家長會費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (41, 1, 0, 'itemName', '繳費項目', '1', 609, 628, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (42, 1, 0, 'amount', '金額', '2', 629, 635, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**體檢費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (43, 1, 0, 'itemName', '繳費項目', '1', 636, 655, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (44, 1, 0, 'amount', '金額', '2', 656, 662, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**游泳教學費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (45, 1, 0, 'itemName', '繳費項目', '1', 663, 682, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (46, 1, 0, 'amount', '金額', '2', 683, 689, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**學生及家長手冊**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (47, 1, 0, 'itemName', '繳費項目', '1', 690, 709, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (48, 1, 0, 'amount', '金額', '2', 710, 716, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**冷氣費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (49, 1, 0, 'itemName', '繳費項目', '1', 717, 736, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (50, 1, 0, 'amount', '金額', '2', 737, 743, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**不可貸書籍費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (51, 1, 0, 'itemName', '繳費項目', '1', 744, 763, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (52, 1, 0, 'amount', '金額', '2', 764, 770, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**不可貸學雜費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (53, 1, 0, 'itemName', '繳費項目', '1', 771, 790, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (54, 1, 0, 'amount', '金額', '2', 791, 797, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());

/**不可助貸 Header**/
/**應繳費用**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (55, 1, 1, 'attribute8', '不可助貸應繳費用', '2', 818, 824, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**手續費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (56, 1, 1, 'attribute9', '不可助貸手續費', '2', 845, 851, 0, 0, 0, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**實繳費用**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (57, 1, 1, 'attribute10', '不可助貸實繳費用', '2', 872, 878, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (58, 1, 1, 'totalLoanableAmount', '有助學貸款', '2', 872, 878, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**應繳合計**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (59, 1, 1, 'totalAmount', '應繳合計', '2', 899, 905, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
GO
SET IDENTITY_INSERT COLUMN_DEFINITION OFF
GO

-- 豫章工商實習規格 匯入格式(明細)
SET IDENTITY_INSERT COLUMN_DEFINITION ON
GO
/**Header**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (60, 2, 1, 'attribute1', '主辦銀行', '1', 1, 40, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (61, 2, 1, 'attribute2', '入帳帳號', '1', 41, 54, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (62, 2, 1, 'paymentName', '繳費類別', '1', 55, 74, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**繳費期限**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (63, 2, 1, 'payDue', '繳費期限', '3', 75, 82, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (64, 2, 1, 'virtualAccount', '繳費帳號', '1', 83, 96, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (65, 2, 1, 'payerName', '姓名', '1', 97, 108, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (66, 2, 1, 'studentId', '學號', '1', 109, 114, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (67, 2, 1, 'department', '科別', '1', 115, 126, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (68, 2, 1, 'grade', '年級', '1', 127, 136, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (69, 2, 1, 'classNo', '班別', '1', 137, 139, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());

/**Items**/
/**簿本費**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (70, 2, 0, 'itemName', '繳費項目', '1', 140, 159, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (71, 2, 0, 'amount', '金額', '2', 160, 166, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**代辦教材**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (72, 2, 0, 'itemName', '繳費項目', '1', 167, 186, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (73, 2, 0, 'amount', '金額', '2', 187, 193, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**手工具**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (74, 2, 0, 'itemName', '繳費項目', '1', 194, 213, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (75, 2, 0, 'amount', '金額', '2', 214, 220, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**製圖工具**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (76, 2, 0, 'itemName', '繳費項目', '1', 221, 240, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (77, 2, 0, 'amount', '金額', '2', 241, 247, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**繪圖工具**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (78, 2, 0, 'itemName', '繳費項目', '1', 248, 267, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (79, 2, 0, 'amount', '金額', '2', 268, 274, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**實習工作服**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (80, 2, 0, 'itemName', '繳費項目', '1', 275, 294, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (81, 2, 0, 'amount', '金額', '2', 295, 301, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**調酒服**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (82, 2, 0, 'itemName', '繳費項目', '1', 302, 321, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (83, 2, 0, 'amount', '金額', '2', 322, 328, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
/**課後輔導**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (84, 2, 0, 'itemName', '繳費項目', '1', 329, 348, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (85, 2, 0, 'amount', '金額', '2', 349, 355, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());

/**應繳合計**/
INSERT INTO COLUMN_DEFINITION (COLUMN_DEF_PK, FORMAT_DEF_PK, IS_HEADER, COLUMN_NAME, COLUMN_TITLE, COLUMN_TYPE, BEGIN_INDEX, END_INDEX, IS_QUERY, IS_DISPLAY, IS_REQUIRED, CREATED_BY, CREATED_DATE, UPDATE_BY, UPDATE_DATE) VALUES (86, 2, 1, 'totalAmount', '應繳合計', '2', 376, 382, 0, 0, 1, 'CYBERSOFT' ,  GETDATE(), 'CYBERSOFT', GETDATE());
GO
SET IDENTITY_INSERT COLUMN_DEFINITION OFF
GO
